package com.person.jc.service.security;

import java.util.List;

import com.jfinal.plugin.activerecord.Db;
import com.jfinal.plugin.activerecord.Record;

public class TsCodeService {
	
	public static final TsCodeService me = new TsCodeService();
	
	
	public List<Record> getKindCode(String typeCode){
    	String sql = 
			"select t.kind_code ID, t.kind_name TEXT, t.idx_no, t.remark\n" +
			"  from ts_code_kind_data t\n" + 
			" where type_code = ?\n" + 
			"   and is_show = 1\n" + 
			" order by t.idx_no";
		return Db.find(sql,typeCode);
	}
}
